Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	18723
Missing cells	74944
Missing cells (%)	20.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	136.0 B

Variable types

Numeric	9
Categorical	7
Unsupported	4

Warnings

`survey_id` has constant value "1476"	Constant
`city` has constant value "Amsterdam"	Constant
`name` has a high cardinality: 18150 distinct values	High cardinality
`last_modified` has a high cardinality: 18723 distinct values	High cardinality
`location` has a high cardinality: 18723 distinct values	High cardinality
`room_id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `room_id`	High correlation
`accommodates` is highly correlated with `bedrooms` and 1 other fields	High correlation
`bedrooms` is highly correlated with `accommodates`	High correlation
`price` is highly correlated with `accommodates`	High correlation
`room_id` is highly correlated with `reviews`	High correlation
`reviews` is highly correlated with `room_id` and 1 other fields	High correlation
`overall_satisfaction` is highly correlated with `reviews`	High correlation
`accommodates` is highly correlated with `bedrooms` and 1 other fields	High correlation
`bedrooms` is highly correlated with `accommodates` and 1 other fields	High correlation
`price` is highly correlated with `accommodates` and 1 other fields	High correlation
`reviews` is highly correlated with `overall_satisfaction`	High correlation
`overall_satisfaction` is highly correlated with `reviews`	High correlation
`accommodates` is highly correlated with `bedrooms`	High correlation
`bedrooms` is highly correlated with `accommodates`	High correlation
`accommodates` is highly correlated with `bedrooms`	High correlation
`bedrooms` is highly correlated with `accommodates`	High correlation
`neighborhood` is highly correlated with `latitude` and 1 other fields	High correlation
`host_id` is highly correlated with `room_id`	High correlation
`room_id` is highly correlated with `host_id`	High correlation
`latitude` is highly correlated with `neighborhood` and 1 other fields	High correlation
`longitude` is highly correlated with `neighborhood` and 1 other fields	High correlation
`neighborhood` is highly correlated with `survey_id` and 1 other fields	High correlation
`room_type` is highly correlated with `survey_id` and 1 other fields	High correlation
`survey_id` is highly correlated with `neighborhood` and 2 other fields	High correlation
`city` is highly correlated with `neighborhood` and 2 other fields	High correlation
`country` has 18723 (100.0%) missing values	Missing
`borough` has 18723 (100.0%) missing values	Missing
`bathrooms` has 18723 (100.0%) missing values	Missing
`minstay` has 18723 (100.0%) missing values	Missing
`name` is uniformly distributed	Uniform
`last_modified` is uniformly distributed	Uniform
`location` is uniformly distributed	Uniform
`room_id` has unique values	Unique
`last_modified` has unique values	Unique
`location` has unique values	Unique
`country` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`borough` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`bathrooms` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`minstay` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`reviews` has 2984 (15.9%) zeros	Zeros
`overall_satisfaction` has 5748 (30.7%) zeros	Zeros
`bedrooms` has 1154 (6.2%) zeros	Zeros

Reproduction

Analysis started	2021-09-07 09:41:18.895388
Analysis finished	2021-09-07 09:41:43.221514
Duration	24.33 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

room_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	18723
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11205678.03

Minimum	2818
Maximum	20003728
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	2818
5-th percentile	1018799.4
Q1	6050607.5
median	12282874
Q3	16610843
95-th percentile	19578785
Maximum	20003728
Range	20000910
Interquartile range (IQR)	10560235.5

Descriptive statistics

Standard deviation	6082192.263
Coefficient of variation (CV)	0.5427777102
Kurtosis	-1.22613161
Mean	11205678.03
Median Absolute Deviation (MAD)	5236951
Skewness	-0.2542978146
Sum	2.098039098 × 10¹¹
Variance	3.699306273 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19075070	1	< 0.1%
13501077	1	< 0.1%
16253557	1	< 0.1%
2953104	1	< 0.1%
3865210	1	< 0.1%
11597089	1	< 0.1%
1333886	1	< 0.1%
13806208	1	< 0.1%
3521399	1	< 0.1%
11614850	1	< 0.1%
Other values (18713)	18713	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2818	1	< 0.1%
3209	1	< 0.1%
20168	1	< 0.1%
25428	1	< 0.1%
25488	1	< 0.1%
27886	1	< 0.1%
28658	1	< 0.1%
28871	1	< 0.1%
29051	1	< 0.1%
29554	1	< 0.1%

Value	Count	Frequency (%)
20003728	1	< 0.1%
19996091	1	< 0.1%
19995673	1	< 0.1%
19995327	1	< 0.1%
19995246	1	< 0.1%
19995106	1	< 0.1%
19994262	1	< 0.1%
19992677	1	< 0.1%
19992596	1	< 0.1%
19992241	1	< 0.1%

survey_id
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.2 KiB

1476	18723

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	74892
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1476
2nd row	1476
3rd row	1476
4th row	1476
5th row	1476

Common Values

Value	Count	Frequency (%)
1476	18723	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1476	18723	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	18723	25.0%
4	18723	25.0%
7	18723	25.0%
6	18723	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	74892	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	18723	25.0%
4	18723	25.0%
7	18723	25.0%
6	18723	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	74892	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	18723	25.0%
4	18723	25.0%
7	18723	25.0%
6	18723	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	74892	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	18723	25.0%
4	18723	25.0%
7	18723	25.0%
6	18723	25.0%

host_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	15943
Distinct (%)	85.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35776116.68

Minimum	2234
Maximum	141831915
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	2234
5-th percentile	1477396.3
Q1	7140879
median	19886414
Q3	52026801
95-th percentile	121891620.7
Maximum	141831915
Range	141829681
Interquartile range (IQR)	44885922

Descriptive statistics

Standard deviation	37581025.87
Coefficient of variation (CV)	1.050450114
Kurtosis	0.4901090157
Mean	35776116.68
Median Absolute Deviation (MAD)	15783470
Skewness	1.243881153
Sum	6.698362327 × 10¹¹
Variance	1.412333505 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48703385	93	0.5%
113977564	88	0.5%
1464510	71	0.4%
107745142	64	0.3%
84453740	61	0.3%
65859990	54	0.3%
517215	52	0.3%
46691672	43	0.2%
84449589	37	0.2%
669178	36	0.2%
Other values (15933)	18124	96.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2234	1	< 0.1%
3159	1	< 0.1%
3806	1	< 0.1%
5988	2	< 0.1%
7924	1	< 0.1%
12085	1	< 0.1%
20405	1	< 0.1%
34080	1	< 0.1%
36701	1	< 0.1%
40786	1	< 0.1%

Value	Count	Frequency (%)
141831915	1	< 0.1%
141749109	1	< 0.1%
141747815	1	< 0.1%
141665148	4	< 0.1%
141658022	1	< 0.1%
141648682	1	< 0.1%
141551211	1	< 0.1%
141548705	1	< 0.1%
141542351	1	< 0.1%
141534602	1	< 0.1%

room_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.2 KiB

Entire home/apt	14978
Private room	3682
Shared room	63

Length

Max length	15
Median length	15
Mean length	14.39657106
Min length	11

Characters and Unicode

Total characters	269547
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Shared room
2nd row	Shared room
3rd row	Shared room
4th row	Shared room
5th row	Shared room

Common Values

Value	Count	Frequency (%)
Entire home/apt	14978	80.0%
Private room	3682	19.7%
Shared room	63	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
home/apt	14978	40.0%
entire	14978	40.0%
room	3745	10.0%
private	3682	9.8%
shared	63	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	33701	12.5%
t	33638	12.5%
r	22468	8.3%
o	22468	8.3%
a	18723	6.9%
	18723	6.9%
m	18723	6.9%
i	18660	6.9%
h	15041	5.6%
E	14978	5.6%
Other values (7)	52424	19.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	217123	80.6%
Uppercase Letter	18723	6.9%
Space Separator	18723	6.9%
Other Punctuation	14978	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	33701	15.5%
t	33638	15.5%
r	22468	10.3%
o	22468	10.3%
a	18723	8.6%
m	18723	8.6%
i	18660	8.6%
h	15041	6.9%
n	14978	6.9%
p	14978	6.9%
Other values (2)	3745	1.7%

Uppercase Letter

Value	Count	Frequency (%)
E	14978	80.0%
P	3682	19.7%
S	63	0.3%

Space Separator

Value	Count	Frequency (%)
	18723	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	14978	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	235846	87.5%
Common	33701	12.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	33701	14.3%
t	33638	14.3%
r	22468	9.5%
o	22468	9.5%
a	18723	7.9%
m	18723	7.9%
i	18660	7.9%
h	15041	6.4%
E	14978	6.4%
n	14978	6.4%
Other values (5)	22468	9.5%

Common

Value	Count	Frequency (%)
	18723	55.6%
/	14978	44.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	269547	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	33701	12.5%
t	33638	12.5%
r	22468	8.3%
o	22468	8.3%
a	18723	6.9%
	18723	6.9%
m	18723	6.9%
i	18660	6.9%
h	15041	5.6%
E	14978	5.6%
Other values (7)	52424	19.4%

country
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18723
Missing (%)	100.0%
Memory size	146.3 KiB

city
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.2 KiB

Amsterdam	18723

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	168507
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Amsterdam
2nd row	Amsterdam
3rd row	Amsterdam
4th row	Amsterdam
5th row	Amsterdam

Common Values

Value	Count	Frequency (%)
Amsterdam	18723	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
amsterdam	18723	100.0%

Most occurring characters

Value	Count	Frequency (%)
m	37446	22.2%
A	18723	11.1%
s	18723	11.1%
t	18723	11.1%
e	18723	11.1%
r	18723	11.1%
d	18723	11.1%
a	18723	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	149784	88.9%
Uppercase Letter	18723	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	37446	25.0%
s	18723	12.5%
t	18723	12.5%
e	18723	12.5%
r	18723	12.5%
d	18723	12.5%
a	18723	12.5%

Uppercase Letter

Value	Count	Frequency (%)
A	18723	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	168507	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	37446	22.2%
A	18723	11.1%
s	18723	11.1%
t	18723	11.1%
e	18723	11.1%
r	18723	11.1%
d	18723	11.1%
a	18723	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	168507	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
m	37446	22.2%
A	18723	11.1%
s	18723	11.1%
t	18723	11.1%
e	18723	11.1%
r	18723	11.1%
d	18723	11.1%
a	18723	11.1%

borough
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18723
Missing (%)	100.0%
Memory size	146.3 KiB

neighborhood
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.2 KiB

De Baarsjes / Oud West	3289
De Pijp / Rivierenbuurt	2378
Centrum West	2225
Centrum Oost	1730
Westerpark	1430
Other values (18)	7671

Length

Max length	38
Median length	15
Mean length	17.51572932
Min length	6

Characters and Unicode

Total characters	327947
Distinct characters	43
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	De Pijp / Rivierenbuurt
2nd row	Centrum West
3rd row	Watergraafsmeer
4th row	Centrum West
5th row	De Baarsjes / Oud West

Common Values

Value	Count	Frequency (%)
De Baarsjes / Oud West	3289	17.6%
De Pijp / Rivierenbuurt	2378	12.7%
Centrum West	2225	11.9%
Centrum Oost	1730	9.2%
Westerpark	1430	7.6%
Noord-West / Noord-Midden	1418	7.6%
Oud Oost	1169	6.2%
Bos en Lommer	988	5.3%
Oostelijk Havengebied / Indische Buurt	921	4.9%
Watergraafsmeer	517	2.8%
Other values (13)	2658	14.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	8985	15.9%
de	5781	10.3%
west	5755	10.2%
oud	4952	8.8%
centrum	4054	7.2%
baarsjes	3289	5.8%
oost	3217	5.7%
rivierenbuurt	2378	4.2%
pijp	2378	4.2%
westerpark	1430	2.5%
Other values (27)	14130	25.1%

Most occurring characters

Value	Count	Frequency (%)
e	41125	12.5%
	37626	11.5%
r	24877	7.6%
s	22215	6.8%
t	22148	6.8%
u	17169	5.2%
d	14742	4.5%
o	14591	4.4%
i	12545	3.8%
a	11932	3.6%
Other values (33)	108977	33.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	229288	69.9%
Uppercase Letter	49212	15.0%
Space Separator	37626	11.5%
Other Punctuation	8985	2.7%
Dash Punctuation	2836	0.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	41125	17.9%
r	24877	10.8%
s	22215	9.7%
t	22148	9.7%
u	17169	7.5%
d	14742	6.4%
o	14591	6.4%
i	12545	5.5%
a	11932	5.2%
n	11659	5.1%
Other values (13)	36285	15.8%

Uppercase Letter

Value	Count	Frequency (%)
O	9253	18.8%
W	9135	18.6%
D	5823	11.8%
B	5644	11.5%
C	4054	8.2%
N	3906	7.9%
P	2378	4.8%
R	2378	4.8%
M	1418	2.9%
I	1299	2.6%
Other values (7)	3924	8.0%

Space Separator

Value	Count	Frequency (%)
	37626	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	8985	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2836	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	278500	84.9%
Common	49447	15.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	41125	14.8%
r	24877	8.9%
s	22215	8.0%
t	22148	8.0%
u	17169	6.2%
d	14742	5.3%
o	14591	5.2%
i	12545	4.5%
a	11932	4.3%
n	11659	4.2%
Other values (30)	85497	30.7%

Common

Value	Count	Frequency (%)
	37626	76.1%
/	8985	18.2%
-	2836	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	327947	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	41125	12.5%
	37626	11.5%
r	24877	7.6%
s	22215	6.8%
t	22148	6.8%
u	17169	5.2%
d	14742	4.5%
o	14591	4.4%
i	12545	3.8%
a	11932	3.6%
Other values (33)	108977	33.2%

reviews
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	284
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.74154783

Minimum	0
Maximum	532
Zeros	2984
Zeros (%)	15.9%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	17
95-th percentile	67
Maximum	532
Range	532
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	33.52262982
Coefficient of variation (CV)	2.00236144
Kurtosis	43.75643505
Mean	16.74154783
Median Absolute Deviation (MAD)	6
Skewness	5.502786616
Sum	313452
Variance	1123.76671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2984	15.9%
1	1510	8.1%
2	1246	6.7%
3	1103	5.9%
4	925	4.9%
5	876	4.7%
6	741	4.0%
7	683	3.6%
8	590	3.2%
9	529	2.8%
Other values (274)	7536	40.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2984	15.9%
1	1510	8.1%
2	1246	6.7%
3	1103	5.9%
4	925	4.9%
5	876	4.7%
6	741	4.0%
7	683	3.6%
8	590	3.2%
9	529	2.8%

Value	Count	Frequency (%)
532	1	< 0.1%
465	1	< 0.1%
463	1	< 0.1%
452	1	< 0.1%
447	1	< 0.1%
443	2	< 0.1%
433	1	< 0.1%
430	2	< 0.1%
425	1	< 0.1%
410	2	< 0.1%

overall_satisfaction
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.301126956

Minimum	0
Maximum	5
Zeros	5748
Zeros (%)	30.7%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4.5
Q3	5
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.213557519
Coefficient of variation (CV)	0.6705460129
Kurtosis	-1.317124352
Mean	3.301126956
Median Absolute Deviation (MAD)	0.5
Skewness	-0.7927016145
Sum	61807
Variance	4.899836888
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
5	7708	41.2%
0	5748	30.7%
4.5	4559	24.3%
4	577	3.1%
3.5	109	0.6%
3	19	0.1%
1	1	< 0.1%
2.5	1	< 0.1%
1.5	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5748	30.7%
1	1	< 0.1%
1.5	1	< 0.1%
2.5	1	< 0.1%
3	19	0.1%
3.5	109	0.6%
4	577	3.1%
4.5	4559	24.3%
5	7708	41.2%

Value	Count	Frequency (%)
5	7708	41.2%
4.5	4559	24.3%
4	577	3.1%
3.5	109	0.6%
3	19	0.1%
2.5	1	< 0.1%
1.5	1	< 0.1%
1	1	< 0.1%
0	5748	30.7%

accommodates
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	16
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.922021044

Minimum	1
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	2
Q3	4
95-th percentile	5
Maximum	17
Range	16
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.327523924
Coefficient of variation (CV)	0.4543170307
Kurtosis	14.34067519
Mean	2.922021044
Median Absolute Deviation (MAD)	0
Skewness	2.388797947
Sum	54709
Variance	1.762319769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
2	10024	53.5%
4	5579	29.8%
3	1585	8.5%
6	476	2.5%
5	471	2.5%
1	367	2.0%
8	105	0.6%
7	52	0.3%
16	20	0.1%
10	16	0.1%
Other values (6)	28	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	367	2.0%
2	10024	53.5%
3	1585	8.5%
4	5579	29.8%
5	471	2.5%
6	476	2.5%
7	52	0.3%
8	105	0.6%
9	8	< 0.1%
10	16	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
16	20	0.1%
14	6	< 0.1%
13	1	< 0.1%
12	10	0.1%
11	2	< 0.1%
10	16	0.1%
9	8	< 0.1%
8	105	0.6%
7	52	0.3%

bedrooms
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.430379747

Minimum	0
Maximum	10
Zeros	1154
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	10
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8790186913
Coefficient of variation (CV)	0.6145351913
Kurtosis	5.625756602
Mean	1.430379747
Median Absolute Deviation (MAD)	0
Skewness	1.601304105
Sum	26781
Variance	0.7726738596
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	11101	59.3%
2	4456	23.8%
3	1444	7.7%
0	1154	6.2%
4	473	2.5%
5	62	0.3%
6	19	0.1%
10	5	< 0.1%
7	4	< 0.1%
8	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1154	6.2%
1	11101	59.3%
2	4456	23.8%
3	1444	7.7%
4	473	2.5%
5	62	0.3%
6	19	0.1%
7	4	< 0.1%
8	3	< 0.1%
9	2	< 0.1%

Value	Count	Frequency (%)
10	5	< 0.1%
9	2	< 0.1%
8	3	< 0.1%
7	4	< 0.1%
6	19	0.1%
5	62	0.3%
4	473	2.5%
3	1444	7.7%
2	4456	23.8%
1	11101	59.3%

bathrooms
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18723
Missing (%)	100.0%
Memory size	146.3 KiB

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	423
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	166.5994766

Minimum	12
Maximum	6000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	12
5-th percentile	72
Q1	108
median	144
Q3	192
95-th percentile	330
Maximum	6000
Range	5988
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	108.9438487
Coefficient of variation (CV)	0.6539267168
Kurtosis	521.8652555
Mean	166.5994766
Median Absolute Deviation (MAD)	36
Skewness	12.76898743
Sum	3119242
Variance	11868.76218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
119	1023	5.5%
180	1001	5.3%
144	887	4.7%
150	621	3.3%
132	588	3.1%
108	562	3.0%
96	520	2.8%
114	509	2.7%
118	508	2.7%
240	495	2.6%
Other values (413)	12009	64.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12	1	< 0.1%
18	1	< 0.1%
21	1	< 0.1%
22	1	< 0.1%
23	1	< 0.1%
24	6	< 0.1%
25	1	< 0.1%
28	1	< 0.1%
29	2	< 0.1%
30	6	< 0.1%

Value	Count	Frequency (%)
6000	1	< 0.1%
3770	1	< 0.1%
1920	1	< 0.1%
1799	1	< 0.1%
1558	1	< 0.1%
1428	1	< 0.1%
1412	1	< 0.1%
1386	1	< 0.1%
1343	1	< 0.1%
1319	1	< 0.1%

minstay
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18723
Missing (%)	100.0%
Memory size	146.3 KiB

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	18150
Distinct (%)	97.2%
Missing	52
Missing (%)	0.3%
Memory size	73.2 KiB

Amsterdam	36
Lovely apartment near Vondelpark	10
Spacious family house with garden	8
Cosy apartment in Amsterdam	8
Beautiful apartment in Amsterdam	8
Other values (18145)	18601

Length

Max length	78
Median length	35
Mean length	36.09233571
Min length	1

Characters and Unicode

Total characters	673880
Distinct characters	157
Distinct categories	20 ?
Distinct scripts	4 ?
Distinct blocks	10 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	17814 ?
Unique (%)	95.4%

Sample

1st row	Red Light/ Canal view apartment (Shared)
2nd row	Sunny and Cozy Living room in quite neighbours
3rd row	Amsterdam
4th row	Canal boat RIDE in Amsterdam
5th row	One room for rent in a three room appartment

Common Values

Value	Count	Frequency (%)
Amsterdam	36	0.2%
Lovely apartment near Vondelpark	10	0.1%
Spacious family house with garden	8	< 0.1%
Cosy apartment in Amsterdam	8	< 0.1%
Beautiful apartment in Amsterdam	8	< 0.1%
Magnificent panoramic city view	8	< 0.1%
Lovely apartment in Amsterdam	7	< 0.1%
Spacious apartment near Vondelpark	7	< 0.1%
Nice comfy room, magnificent view	7	< 0.1%
Apartment in Amsterdam	6	< 0.1%
Other values (18140)	18566	99.2%
(Missing)	52	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
apartment	7118	6.7%
in	5730	5.4%
amsterdam	3588	3.4%
	3195	3.0%
with	2669	2.5%
the	2165	2.0%
spacious	2082	2.0%
city	1906	1.8%
centre	1768	1.7%
room	1728	1.6%
Other values (4867)	73723	69.8%

Most occurring characters

Value	Count	Frequency (%)
	87491	13.0%
e	59230	8.8%
t	55217	8.2%
a	52626	7.8%
r	42831	6.4%
n	39759	5.9%
o	35472	5.3%
i	32482	4.8%
m	26379	3.9%
s	21195	3.1%
Other values (147)	221198	32.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	510398	75.7%
Space Separator	87492	13.0%
Uppercase Letter	54936	8.2%
Other Punctuation	11184	1.7%
Decimal Number	5572	0.8%
Dash Punctuation	1595	0.2%
Math Symbol	1136	0.2%
Close Punctuation	621	0.1%
Open Punctuation	588	0.1%
Other Symbol	236	< 0.1%
Other values (10)	122	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
阿	2	5.1%
姆	2	5.1%
斯	2	5.1%
特	2	5.1%
丹	2	5.1%
公	2	5.1%
到	2	5.1%
獨	1	2.6%
立	1	2.6%
寓	1	2.6%
Other values (22)	22	56.4%

Lowercase Letter

Value	Count	Frequency (%)
e	59230	11.6%
t	55217	10.8%
a	52626	10.3%
r	42831	8.4%
n	39759	7.8%
o	35472	6.9%
i	32482	6.4%
m	26379	5.2%
s	21195	4.2%
p	19825	3.9%
Other values (20)	125382	24.6%

Uppercase Letter

Value	Count	Frequency (%)
A	8892	16.2%
C	6863	12.5%
S	4399	8.0%
L	3283	6.0%
B	3251	5.9%
R	2791	5.1%
P	2694	4.9%
E	2341	4.3%
T	2219	4.0%
N	2194	4.0%
Other values (17)	16009	29.1%

Other Punctuation

Value	Count	Frequency (%)
,	2817	25.2%
!	2756	24.6%
&	1686	15.1%
.	1473	13.2%
'	831	7.4%
/	587	5.2%
@	315	2.8%
"	285	2.5%
:	189	1.7%
*	154	1.4%
Other values (7)	91	0.8%

Decimal Number

Value	Count	Frequency (%)
2	1885	33.8%
1	992	17.8%
0	741	13.3%
5	498	8.9%
3	463	8.3%
4	412	7.4%
8	150	2.7%
6	150	2.7%
9	145	2.6%
7	136	2.4%

Other Symbol

Value	Count	Frequency (%)
★	171	72.5%
☆	33	14.0%
❤	14	5.9%
♡	5	2.1%
♥	5	2.1%
⭐	3	1.3%
°	3	1.3%
☕	1	0.4%
☺	1	0.4%

Math Symbol

Value	Count	Frequency (%)
+	660	58.1%
\|	460	40.5%
<	5	0.4%
>	4	0.4%
=	3	0.3%
~	2	0.2%
⊕	1	0.1%
÷	1	0.1%

Open Punctuation

Value	Count	Frequency (%)
(	581	98.8%
[	6	1.0%
【	1	0.2%

Close Punctuation

Value	Count	Frequency (%)
)	614	98.9%
]	6	1.0%
】	1	0.2%

Space Separator

Value	Count	Frequency (%)
	87491	> 99.9%
	1	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1593	99.9%
–	2	0.1%

Nonspacing Mark

Value	Count	Frequency (%)
️	15	93.8%
︎	1	6.2%

Control

Value	Count	Frequency (%)
	6	50.0%
	6	50.0%

Final Punctuation

Value	Count	Frequency (%)
’	9	81.8%
”	2	18.2%

Initial Punctuation

Value	Count	Frequency (%)
‘	3	60.0%
“	2	40.0%

Currency Symbol

Value	Count	Frequency (%)
€	4	80.0%
$	1	20.0%

Other Number

Value	Count	Frequency (%)
²	22	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	7	100.0%

Modifier Symbol

Value	Count	Frequency (%)
´	4	100.0%

Format

Value	Count	Frequency (%)
‏	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	565334	83.9%
Common	108491	16.1%
Han	39	< 0.1%
Inherited	16	< 0.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
	87491	80.6%
,	2817	2.6%
!	2756	2.5%
2	1885	1.7%
&	1686	1.6%
-	1593	1.5%
.	1473	1.4%
1	992	0.9%
'	831	0.8%
0	741	0.7%
Other values (56)	6226	5.7%

Latin

Value	Count	Frequency (%)
e	59230	10.5%
t	55217	9.8%
a	52626	9.3%
r	42831	7.6%
n	39759	7.0%
o	35472	6.3%
i	32482	5.7%
m	26379	4.7%
s	21195	3.7%
p	19825	3.5%
Other values (47)	180318	31.9%

Han

Value	Count	Frequency (%)
阿	2	5.1%
姆	2	5.1%
斯	2	5.1%
特	2	5.1%
丹	2	5.1%
公	2	5.1%
到	2	5.1%
獨	1	2.6%
立	1	2.6%
寓	1	2.6%
Other values (22)	22	56.4%

Inherited

Value	Count	Frequency (%)
️	15	93.8%
︎	1	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	673492	99.9%
Misc Symbols	216	< 0.1%
Latin 1 Sup	57	< 0.1%
CJK	39	< 0.1%
Punctuation	34	< 0.1%
VS	16	< 0.1%
Dingbats	14	< 0.1%
None	7	< 0.1%
Currency Symbols	4	< 0.1%
Math Operators	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	87491	13.0%
e	59230	8.8%
t	55217	8.2%
a	52626	7.8%
r	42831	6.4%
n	39759	5.9%
o	35472	5.3%
i	32482	4.8%
m	26379	3.9%
s	21195	3.1%
Other values (82)	220810	32.8%

Latin 1 Sup

Value	Count	Frequency (%)
²	22	38.6%
é	15	26.3%
à	4	7.0%
´	4	7.0%
°	3	5.3%
É	3	5.3%
á	2	3.5%
¡	1	1.8%
	1	1.8%
÷	1	1.8%

Misc Symbols

Value	Count	Frequency (%)
★	171	79.2%
☆	33	15.3%
♡	5	2.3%
♥	5	2.3%
☕	1	0.5%
☺	1	0.5%

None

Value	Count	Frequency (%)
⭐	3	42.9%
，	2	28.6%
【	1	14.3%
】	1	14.3%

VS

Value	Count	Frequency (%)
️	15	93.8%
︎	1	6.2%

Dingbats

Value	Count	Frequency (%)
❤	14	100.0%

Punctuation

Value	Count	Frequency (%)
•	15	44.1%
’	9	26.5%
‘	3	8.8%
“	2	5.9%
”	2	5.9%
–	2	5.9%
‏	1	2.9%

Math Operators

Value	Count	Frequency (%)
⊕	1	100.0%

Currency Symbols

Value	Count	Frequency (%)
€	4	100.0%

CJK

Value	Count	Frequency (%)
阿	2	5.1%
姆	2	5.1%
斯	2	5.1%
特	2	5.1%
丹	2	5.1%
公	2	5.1%
到	2	5.1%
獨	1	2.6%
立	1	2.6%
寓	1	2.6%
Other values (22)	22	56.4%

last_modified
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	18723
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	73.2 KiB

2017-07-22 16:33:46.800407	1
2017-07-23 02:50:22.347298	1
2017-07-23 02:58:55.274841	1
2017-07-22 16:18:32.872076	1
2017-07-22 16:35:28.316834	1
Other values (18718)	18718

Length

Max length	26
Median length	26
Mean length	26
Min length	26

Characters and Unicode

Total characters	486798
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18723 ?
Unique (%)	100.0%

Sample

1st row	2017-07-23 13:06:27.391699
2nd row	2017-07-23 13:06:23.607187
3rd row	2017-07-23 13:06:23.603546
4th row	2017-07-23 13:06:22.689787
5th row	2017-07-23 13:06:19.681469

Common Values

Value	Count	Frequency (%)
2017-07-22 16:33:46.800407	1	< 0.1%
2017-07-23 02:50:22.347298	1	< 0.1%
2017-07-23 02:58:55.274841	1	< 0.1%
2017-07-22 16:18:32.872076	1	< 0.1%
2017-07-22 16:35:28.316834	1	< 0.1%
2017-07-22 16:07:42.762415	1	< 0.1%
2017-07-22 16:36:48.299793	1	< 0.1%
2017-07-23 03:14:27.692034	1	< 0.1%
2017-07-22 17:28:36.876880	1	< 0.1%
2017-07-22 22:31:47.200359	1	< 0.1%
Other values (18713)	18713	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2017-07-22	13694	36.6%
2017-07-23	5029	13.4%
16:53:58.788720	1	< 0.1%
16:26:25.984506	1	< 0.1%
06:00:35.058421	1	< 0.1%
22:58:38.711519	1	< 0.1%
16:07:14.409025	1	< 0.1%
22:31:51.403592	1	< 0.1%
18:22:52.948279	1	< 0.1%
05:53:53.016982	1	< 0.1%
Other values (18715)	18715	50.0%

Most occurring characters

Value	Count	Frequency (%)
2	81800	16.8%
0	65421	13.4%
7	55572	11.4%
1	48766	10.0%
-	37446	7.7%
:	37446	7.7%
3	29626	6.1%
5	22515	4.6%
4	19641	4.0%
6	19288	4.0%
Other values (4)	69277	14.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	374460	76.9%
Other Punctuation	56169	11.5%
Dash Punctuation	37446	7.7%
Space Separator	18723	3.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	81800	21.8%
0	65421	17.5%
7	55572	14.8%
1	48766	13.0%
3	29626	7.9%
5	22515	6.0%
4	19641	5.2%
6	19288	5.2%
8	16269	4.3%
9	15562	4.2%

Other Punctuation

Value	Count	Frequency (%)
:	37446	66.7%
.	18723	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	37446	100.0%

Space Separator

Value	Count	Frequency (%)
	18723	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	486798	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	81800	16.8%
0	65421	13.4%
7	55572	11.4%
1	48766	10.0%
-	37446	7.7%
:	37446	7.7%
3	29626	6.1%
5	22515	4.6%
4	19641	4.0%
6	19288	4.0%
Other values (4)	69277	14.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	486798	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	81800	16.8%
0	65421	13.4%
7	55572	11.4%
1	48766	10.0%
-	37446	7.7%
:	37446	7.7%
3	29626	6.1%
5	22515	4.6%
4	19641	4.0%
6	19288	4.0%
Other values (4)	69277	14.2%

latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	15595
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.36526062

Minimum	52.2962
Maximum	52.42498
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	52.2962
5-th percentile	52.3432883
Q1	52.3552535
median	52.364628
Q3	52.3747975
95-th percentile	52.3893716
Maximum	52.42498
Range	0.12878
Interquartile range (IQR)	0.019544

Descriptive statistics

Standard deviation	0.01514204237
Coefficient of variation (CV)	0.0002891619786
Kurtosis	1.418259861
Mean	52.36526062
Median Absolute Deviation (MAD)	0.009735
Skewness	0.007905417451
Sum	980434.7747
Variance	0.0002292814473
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52.361364	5	< 0.1%
52.354646	5	< 0.1%
52.366852	5	< 0.1%
52.360546	5	< 0.1%
52.362453	4	< 0.1%
52.361144	4	< 0.1%
52.361118	4	< 0.1%
52.367149	4	< 0.1%
52.373259	4	< 0.1%
52.369917	4	< 0.1%
Other values (15585)	18679	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
52.2962	1	< 0.1%
52.297203	1	< 0.1%
52.299763	1	< 0.1%
52.299846	1	< 0.1%
52.299875	1	< 0.1%
52.300105	1	< 0.1%
52.30013	1	< 0.1%
52.300915	1	< 0.1%
52.301257	1	< 0.1%
52.301683	1	< 0.1%

Value	Count	Frequency (%)
52.42498	1	< 0.1%
52.424641	1	< 0.1%
52.424255	1	< 0.1%
52.423647	1	< 0.1%
52.423498	1	< 0.1%
52.423432	1	< 0.1%
52.423321	1	< 0.1%
52.422827	1	< 0.1%
52.422232	1	< 0.1%
52.422228	1	< 0.1%

longitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	17157
Distinct (%)	91.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.888585181

Minimum	4.763264
Maximum	5.027689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	146.3 KiB

Quantile statistics

Minimum	4.763264
5-th percentile	4.8453101
Q1	4.8643445
median	4.885994
Q3	4.90748
95-th percentile	4.9445407
Maximum	5.027689
Range	0.264425
Interquartile range (IQR)	0.0431355

Descriptive statistics

Standard deviation	0.03453688189
Coefficient of variation (CV)	0.007064801084
Kurtosis	1.217000077
Mean	4.888585181
Median Absolute Deviation (MAD)	0.021585
Skewness	0.5382471118
Sum	91528.98035
Variance	0.001192796211
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.907187	5	< 0.1%
4.893506	4	< 0.1%
4.888738	4	< 0.1%
4.893017	4	< 0.1%
4.875611	4	< 0.1%
4.891295	4	< 0.1%
4.861512	4	< 0.1%
4.86301	4	< 0.1%
4.877004	4	< 0.1%
4.856525	4	< 0.1%
Other values (17147)	18682	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.763264	1	< 0.1%
4.768452	1	< 0.1%
4.769151	1	< 0.1%
4.771083	1	< 0.1%
4.772725	1	< 0.1%
4.772822	1	< 0.1%
4.775168	1	< 0.1%
4.775748	1	< 0.1%
4.77647	1	< 0.1%
4.77764	1	< 0.1%

Value	Count	Frequency (%)
5.027689	1	< 0.1%
5.026701	1	< 0.1%
5.015737	1	< 0.1%
5.013557	1	< 0.1%
5.013316	1	< 0.1%
5.013075	1	< 0.1%
5.012549	1	< 0.1%
5.011693	1	< 0.1%
5.011688	1	< 0.1%
5.011569	1	< 0.1%

location
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	18723
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	73.2 KiB

0101000020E610000005F9D9C87573134070404B57B02F4A40	1
0101000020E6100000EC4D0CC9C964134032C7F2AE7A304A40	1
0101000020E6100000E63BF88903681340F20A444FCA304A40	1
0101000020E6100000B9FC87F4DBD713406ADE718A8E304A40	1
0101000020E6100000ADFA5C6DC57E134007616EF7722F4A40	1
Other values (18718)	18718

Length

Max length	50
Median length	50
Mean length	50
Min length	50

Characters and Unicode

Total characters	936150
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18723 ?
Unique (%)	100.0%

Sample

1st row	0101000020E610000033FAD170CA8C13403BC5AA41982D4A40
2nd row	0101000020E6100000842A357BA095134042791F4773304A40
3rd row	0101000020E6100000A51133FB3CC613403543AA285E2B4A40
4th row	0101000020E6100000DF180280638F134085EE92382B304A40
5th row	0101000020E6100000CD902A8A57691340187B2FBE682F4A40

Common Values

Value	Count	Frequency (%)
0101000020E610000005F9D9C87573134070404B57B02F4A40	1	< 0.1%
0101000020E6100000EC4D0CC9C964134032C7F2AE7A304A40	1	< 0.1%
0101000020E6100000E63BF88903681340F20A444FCA304A40	1	< 0.1%
0101000020E6100000B9FC87F4DBD713406ADE718A8E304A40	1	< 0.1%
0101000020E6100000ADFA5C6DC57E134007616EF7722F4A40	1	< 0.1%
0101000020E6100000CD751A69A99C1340CC441152B7354A40	1	< 0.1%
0101000020E6100000C6C03A8E1F6A13404833164D672D4A40	1	< 0.1%
0101000020E61000007F83F6EAE361134021AF0793E22F4A40	1	< 0.1%
0101000020E6100000DC291DACFFA313406D74CE4F712E4A40	1	< 0.1%
0101000020E6100000EA79371614A6134052F2EA1C032E4A40	1	< 0.1%
Other values (18713)	18713	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0101000020e610000022c5008926801340f418e599972f4a40	1	< 0.1%
0101000020e610000018213cda38b213408c31b08ee32f4a40	1	< 0.1%
0101000020e61000004c8a8f4fc86e1340d5963ac8eb2f4a40	1	< 0.1%
0101000020e61000004260e5d0227b13408655bc91792e4a40	1	< 0.1%
0101000020e61000006fd74b53049813406daaee91cd2d4a40	1	< 0.1%
0101000020e6100000f01307d0ef6b13402e3bc43f6c2f4a40	1	< 0.1%
0101000020e61000004e9a0645f3c013405589b2b7942f4a40	1	< 0.1%
0101000020e61000002575029a087b1340c362d4b5f62e4a40	1	< 0.1%
0101000020e6100000520dfb3db1fe1340855e7f129f2d4a40	1	< 0.1%
0101000020e61000003d1059a489871340639cbf0985304a40	1	< 0.1%
Other values (18713)	18713	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	289829	31.0%
1	100408	10.7%
4	81235	8.7%
2	58034	6.2%
3	48096	5.1%
E	47519	5.1%
6	46156	4.9%
A	45108	4.8%
D	28544	3.0%
8	28194	3.0%
Other values (6)	163027	17.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	732898	78.3%
Uppercase Letter	203252	21.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	289829	39.5%
1	100408	13.7%
4	81235	11.1%
2	58034	7.9%
3	48096	6.6%
6	46156	6.3%
8	28194	3.8%
7	28082	3.8%
9	27873	3.8%
5	24991	3.4%

Uppercase Letter

Value	Count	Frequency (%)
E	47519	23.4%
A	45108	22.2%
D	28544	14.0%
F	28123	13.8%
C	27427	13.5%
B	26531	13.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	732898	78.3%
Latin	203252	21.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	289829	39.5%
1	100408	13.7%
4	81235	11.1%
2	58034	7.9%
3	48096	6.6%
6	46156	6.3%
8	28194	3.8%
7	28082	3.8%
9	27873	3.8%
5	24991	3.4%

Latin

Value	Count	Frequency (%)
E	47519	23.4%
A	45108	22.2%
D	28544	14.0%
F	28123	13.8%
C	27427	13.5%
B	26531	13.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	936150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	289829	31.0%
1	100408	10.7%
4	81235	8.7%
2	58034	6.2%
3	48096	5.1%
E	47519	5.1%
6	46156	4.9%
A	45108	4.8%
D	28544	3.0%
8	28194	3.0%
Other values (6)	163027	17.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	room_id	survey_id	host_id	room_type	country	city	borough	neighborhood	reviews	overall_satisfaction	accommodates	bedrooms	bathrooms	price	minstay	name	last_modified	latitude	longitude	location
0	10176931	1476	49180562	Shared room	NaN	Amsterdam	NaN	De Pijp / Rivierenbuurt	7	4.5	2	1.0	NaN	156.0	NaN	Red Light/ Canal view apartment (Shared)	2017-07-23 13:06:27.391699	52.356209	4.887491	0101000020E610000033FAD170CA8C13403BC5AA41982D4A40
1	8935871	1476	46718394	Shared room	NaN	Amsterdam	NaN	Centrum West	45	4.5	4	1.0	NaN	126.0	NaN	Sunny and Cozy Living room in quite neighbours	2017-07-23 13:06:23.607187	52.378518	4.896120	0101000020E6100000842A357BA095134042791F4773304A40
2	14011697	1476	10346595	Shared room	NaN	Amsterdam	NaN	Watergraafsmeer	1	0.0	3	1.0	NaN	132.0	NaN	Amsterdam	2017-07-23 13:06:23.603546	52.338811	4.943592	0101000020E6100000A51133FB3CC613403543AA285E2B4A40
3	6137978	1476	8685430	Shared room	NaN	Amsterdam	NaN	Centrum West	7	5.0	4	1.0	NaN	121.0	NaN	Canal boat RIDE in Amsterdam	2017-07-23 13:06:22.689787	52.376319	4.890028	0101000020E6100000DF180280638F134085EE92382B304A40
4	18630616	1476	70191803	Shared room	NaN	Amsterdam	NaN	De Baarsjes / Oud West	1	0.0	2	1.0	NaN	93.0	NaN	One room for rent in a three room appartment	2017-07-23 13:06:19.681469	52.370384	4.852873	0101000020E6100000CD902A8A57691340187B2FBE682F4A40
5	5790170	1476	29968916	Shared room	NaN	Amsterdam	NaN	De Pijp / Rivierenbuurt	184	4.5	2	1.0	NaN	102.0	NaN	Beautiful apartment	2017-07-23 13:06:19.663975	52.342265	4.897126	0101000020E6100000B090B932A896134060C8EA56CF2B4A40
6	934060	1476	5037506	Shared room	NaN	Amsterdam	NaN	Oostelijk Havengebied / Indische Buurt	67	5.0	16	1.0	NaN	462.0	NaN	LOTUS, Classic Dutch Saling Barge	2017-07-23 13:06:09.988016	52.377552	4.930418	0101000020E61000005D70067FBFB813400B45BA9F53304A40
7	19590049	1476	132687356	Shared room	NaN	Amsterdam	NaN	Westerpark	2	0.0	2	1.0	NaN	414.0	NaN	big boot Adam 04	2017-07-23 13:06:09.984748	52.375205	4.866117	0101000020E6100000DD09F65FE7761340D925AAB706304A40
8	5020280	1476	4059485	Shared room	NaN	Amsterdam	NaN	Oud Oost	2	0.0	2	1.0	NaN	222.0	NaN	Bright modern appartment in East!	2017-07-23 13:06:07.452609	52.357346	4.912887	0101000020E610000032C687D9CBA613409FAD8383BD2D4A40
9	15810783	1476	84978218	Shared room	NaN	Amsterdam	NaN	Centrum West	0	0.0	12	1.0	NaN	301.0	NaN	CANAL BOATTOUR AMSTERDAM covered boat 1,5 hour	2017-07-23 13:06:07.447989	52.386610	4.890128	0101000020E6100000FB03E5B67D8F13403D27BD6F7C314A40

Last rows

	room_id	survey_id	host_id	room_type	country	city	borough	neighborhood	reviews	overall_satisfaction	accommodates	bedrooms	bathrooms	price	minstay	name	last_modified	latitude	longitude	location
18713	2763386	1476	14122005	Private room	NaN	Amsterdam	NaN	Slotervaart	118	5.0	2	1.0	NaN	36.0	NaN	Comfortable SKY ROOM 12th floor	2017-07-22 16:05:14.173175	52.361043	4.846134	0101000020E6100000792288F37062134091B932A8362E4A40
18714	19203256	1476	132265798	Private room	NaN	Amsterdam	NaN	Bijlmer Centrum	1	0.0	4	1.0	NaN	35.0	NaN	NEW Stylish room, Ziggodome, AFAS LIVE, ArenA, RAI	2017-07-22 16:05:14.168799	52.320049	4.955609	0101000020E6100000950D6B2A8BD213400A0F9A5DF7284A40
18715	19734178	1476	139135665	Private room	NaN	Amsterdam	NaN	Osdorp	0	0.0	1	0.0	NaN	30.0	NaN	Cozy Apartment in Nieuw-West	2017-07-22 16:05:14.166410	52.356702	4.792346	0101000020E61000003677F4BF5C2B13407A354069A82D4A40
18716	288967	1476	1501422	Private room	NaN	Amsterdam	NaN	De Baarsjes / Oud West	281	5.0	3	1.0	NaN	36.0	NaN	BandB de Baarsjes Amsterdam	2017-07-22 16:05:14.163973	52.361918	4.855507	0101000020E61000000DFFE9060A6C1340B8EA3A54532E4A40
18717	16685383	1476	5831960	Private room	NaN	Amsterdam	NaN	Bos en Lommer	5	5.0	2	1.0	NaN	30.0	NaN	A nice bed in the attic of my 'palace'.	2017-07-22 16:05:14.161714	52.379638	4.848829	0101000020E6100000E695EB6D33651340D0285DFA97304A40
18718	17789893	1476	47501089	Private room	NaN	Amsterdam	NaN	Bijlmer Centrum	10	5.0	3	1.0	NaN	32.0	NaN	1-3 pers. Cozy Rm AFAS Live, ArenA, ZIGGODOME	2017-07-22 16:05:14.158963	52.319794	4.955638	0101000020E6100000684293C492D2134080BA8102EF284A40
18719	16877166	1476	67093870	Private room	NaN	Amsterdam	NaN	Bijlmer Centrum	6	5.0	4	1.0	NaN	24.0	NaN	Modern Room by Arena, ZIGGO, HmH	2017-07-22 16:05:14.151986	52.319080	4.954822	0101000020E61000005801BEDBBCD1134062670A9DD7284A40
18720	19859427	1476	29724632	Private room	NaN	Amsterdam	NaN	Geuzenveld / Slotermeer	0	0.0	1	1.0	NaN	38.0	NaN	Private single room	2017-07-22 16:05:14.149610	52.384028	4.838403	0101000020E61000002079E750865A1340C85F5AD427314A40
18721	17132164	1476	115156569	Private room	NaN	Amsterdam	NaN	Centrum West	13	4.5	2	1.0	NaN	36.0	NaN	City Center studio in Touristic Amsterdam 1	2017-07-22 16:05:14.146183	52.372120	4.890982	0101000020E6100000774CDD955D9013400118CFA0A12F4A40
18722	7605782	1476	39503013	Private room	NaN	Amsterdam	NaN	Centrum West	113	4.5	2	1.0	NaN	35.0	NaN	I have a room available for rent	2017-07-22 16:05:12.257054	52.381392	4.899658	0101000020E6100000CD565EF23F9913405F7AFB73D1304A40

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Other Symbol

Math Symbol

Open Punctuation

Close Punctuation

Space Separator

Dash Punctuation

Nonspacing Mark